create external table jms_dm.dm_cus_active_laxin_volume_cnt_dt
(
input_time date comment '日期'
,customer_code string comment '客户编码'
,customer_name string comment '客户名称'
,waybill_cnt int comment '客户发货量'
,acc_waybill_cnt int comment '累计发货量'
,date_time date comment'查询日期'
)comment '拉新活动客户货量'
PARTITIONED BY (dt string COMMENT '日期分区 yyyy-MM-dd,运单录入时间')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_cus_active_laxin_volume_cnt_dt'
TBLPROPERTIES (
    'discover.partitions' = 'false',
    'parquet.column.index.access' = 'true'
);